Rolling Forecasting calculation methods
| Calc Method | Description |
|---|---|
| Depreciation | Used for Depreciation expense – Inflation can be applied to existing depreciation expense plus an input for depreciation for new capital purchases. |
| Expense | Used for NonSalary expenses. Inputs for Variable percentage and Expense Adjustments along with global lookup for inflation rate. |
| GlobalData | Pulls a calculated value from the RFGlobalData tab in the Driver table. No inputs are allowed in the plan file. |
| IP Census |
Intended for forecasting at the entity level. Used to forecast patient days, admissions, adjusted admissions, and CMI adjusted admissions. (Discharges can be substituted for admissions.) Also includes Average Daily Census and Average Length of Stay. |
| IP Revenue | Calculates gross revenue on a rate-per-key inpatient-statistic basis. Deductions are an optional component using a percent-of-inpatient-revenue basis. |
| IP Revenue_NetPerUnit | Intended for forecasting at the entity level. Calculates gross revenue on a rate-per-patient-day basis. Deductions are optional using a rate per admission or discharge. |
| IP Volume | Calculates inpatient statistics using a relationship to the inpatient global driver along with the historical growth of the statistic within the forecast group. Any of the four forecast methods can be used as the basis for the forecast. |
| NoForecast | Populates with historical data for reconciliation purposes, but no forecast is calculated. |
| OP Revenue | Calculates gross revenue on a rate-per-key outpatient statistic basis. Deductions are an optional component using a percent of outpatient revenue basis. |
| OP Revenue_NetPerUnit | Intended for forecasting at the entity level. Calculates gross revenue on a rate-per-outpatient key statistic basis. Deductions are an optional component using a rate-per-key-statistic basis. Normally the outpatient key statistic would be outpatient visits. |
| OP Volume | Calculates outpatient statistics using a relationship to the outpatient global driver along with the historical growth of the statistic within the forecast group. Any of the four forecast methods can be used as the basis for the forecast. |
| Oth Pt Revenue | Calculates gross revenue on a rate-per-key other patient statistic basis. Deductions are an optional component using a percent of other patient revenue basis. |
| Oth Pt Revenue_Net PerUnit | Intended for forecasting at the entity level. Calculates gross revenue on a rate per other key statistic basis. Deductions are an optional component using a rate per key statistic basis. Normally the other key statistic would be physician visits. |
| Other Deduction | Used for calculating deductions on a percentage of gross revenue basis where there is no directly assigned gross revenue category. Commonly used for bad debt and charity care. |
| Other Revenue | Used for Other Operating and NonOperating Revenue – Inputs for Variable percentage and Revenue Adjustments along with global lookup for inflation rate. Different forecast methods can be used as the basis for the forecast. |
| Other Volume | Calculates other patient statistics using a relationship to the other patient global driver along with the historical growth of the statistic within the forecast group. Use any of the four forecast methods as the basis for the forecast. |
| Pct of Salaries | Used for benefits where salary cost drives the benefit expense such as FICA or pension expense as a percentage of salaries. |
| Rate Per FTE | Used for benefits where FTEs (employees) drive the benefit expense, such as health insurance, using a rate-per-FTE basis. |
| Return Rate | Used for NonOperating Revenue such as Investment Income where a return rate is defined in the Driver table and multiplied times the estimated cash balance. |
| Salary |
Used for FTEs and salary expenses:
|
